About Excel Add-In

The Excel Add-In is an alternative way to enter, update, manage, query and analyze application data, using Excel spreadsheets and workbooks.

You can use the Excel Add-In to:

  • Query and submit data into the application.

  • Change the cube point of view.

  • Interact with forms.

  • Leverage multiple cube views.

  • Establish a live connection to cube views in the application.

  • Drill through to source data.

  • Create functions to return, amend, or submit application data.

  • Refresh sheets and workbooks when changes occur in the application.

You can launch Excel documents from:

  • The Navigation pane

    • The OnePlace tab: Through public and user-specific access to application functionality and documents.

    • The Application tab: Through the Spreadsheet tool.

    • The System tab: Using export features for system administrators.

  • Workflow forms that have attached templates.

  • Cell or data unit attachments.

  • Dashboards

  • Cube views

  • File Explorer

Get Started

Before you start using Excel Add-In, you must add the OneStream ribbon to your Excel program.

Add the OneStream Ribbon

  1. In an Excel workbook, navigate to File > Options to open the Excel Options dialog.

  2. Select Add-ins from the menu in the left pane. Click the Manage drop down menu at the bottom of the dialog box and select COM Add-ins and then click Go.

  3. Click the box next to OneStreamExcelAddIn and then click OK.

  4. The OneStream ribbon is displayed at the top of your workbook page.

Log Into the Excel Add-In

  1. From the OneStream ribbon in Excel, click Log In.

  2. In the Server Address field, click the ellipsis to add or select the URL for the server.

  3. Select an available connection or add a new connection by entering the URL and description and clicking Add. After you select a connection, click OK.

  4. Click Connect to authenticate the server.

  5. Enter your username and password and click Logon.

  6. In the application field, select an application and click Open Application.

    After completing the authentication files and opening the application, your username and application name display in your Excel workbook, indicating that you are logged into the Excel Add-In.

Update the Excel Add-In

If you use the Excel Add-In provided with the Windows application, update the Excel Add-In as part of your client update. See Client Updater. Otherwise, update the Excel Add-In by uninstalling then reinstalling it as described in the Installation Guide.